Use in pass - through queries and commands 用在传递查询和命令中
Pass - through query 直接传递查询
The opendatasource and openrowset syntax can specify a table name , but not a pass - through query Opendatasource和openrowset语法可以指定表名,但不能指定直接传递查询。
Data type from remote instances of sql server can be consumed in pass - through queries 传递查询中可以使用公共语言运行时( clr )用户定义类型的列或来自sql server远程实例的
All these providers support being referenced in a select statement by specifying a pass - through query in the openquery and openrowset functions 通过在openquery函数和openrowset函数中指定传递查询,就可以在select语句中引用所有这些提供程序。
If a provider does not support being used in a four - part name , the provider can be referenced in an openquery or openrowset function by using a pass - through query 如果提供程序不能在由四部分组成的名称中使用,则可以在openquery函数或openrowset函数中通过使用传递查询来引用该提供程序。